package com.example.mapper;

import com.baomidou.dynamic.datasource.annotation.DS;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.entity.vo.PurchaseOrder.PurtdListVo;
import com.example.entity.vo.RequisitionPurchaseVo;
import com.example.entity.yifei.Purtd;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author LiangPandeng
 * @since 2024-02-19
 */
public interface PurtdMapper extends BaseMapper<Purtd> {

    List<PurtdListVo> getPurtdListByTC001TC002(@Param("TC001")String TC001, @Param("TC002")String TC002);

    Integer generateTd003(@Param("td001")String td001, @Param("td002")String td002);

    RequisitionPurchaseVo select90000001(@Param("productName")String productName, @Param("specifications")String specifications);

    Double getTd010Double(@Param("TC004")String TC004,@Param("TD004")String TD004);

    @DS("erp3_help")
    @Select("SELECT * FROM PURTD")
    List<Purtd> all();

    List<String> getPurtdKeyList();
}
